SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55040 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55040 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690089,482848,207542,629856,319436,598531,160468,406806,188547,805426,568155,221984,699633,661306,672077,672278,663972,778382,167784,747791,442948,742935,752290,260973,776122,332210,916935,712606,848040,200357,492999,37009,905449,336156,4357,494103,564982,840764,516737,109586,879312,975677,806592,127595,76640,968788,470312,384939,158116,284519,816409,564877,973554,320673,164959,17261,402483,376764,802768,562802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001316s ]