SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601979 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601979 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432774,774571,428187,317773,922255,835833,395615,133517,182991,169666,460716,1023211,409227,585700,472960,761536,95706,199018,211196,339105,942081,72332,833909,529163,823809,987267,859443,74477,939397,256816,530663,323350,48248,827084,750329,599142,516769,357330,772230,864577,449829,864131,275445,399737,48622,150375,269443,758984,285106,263732,347447,320887,795675,845166,307330,596287,840128,13638,137854,396682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]