SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018809 LIMIT 1 [ RunTime:0.001214s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018809 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204689,726314,484196,704485,526802,1017312,605660,735004,753912,484442,736532,682862,642039,684593,324261,109359,1021473,411755,991050,361689,538168,183710,355974,647601,464385,992716,319116,12657,391708,279809,273164,246055,108966,752637,147730,808084,353543,43173,130628,437668,765543,258922,543452,765712,536888,705977,660138,382228,654776,50217,822905,228331,518153,402809,930257,256597,179922,746428,306275,765841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000874s ]