SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504368 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504368 [ RunTime:0.003490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843196,60720,1045553,290427,407474,12154,330638,589992,673783,539116,1034079,77308,24364,489502,406637,98860,310683,301429,838715,499355,746685,1035310,678220,719887,535381,841955,52089,578172,642514,47501,758064,77905,181809,139831,719243,402151,353923,118627,628077,494605,89276,89640,797148,945172,386366,452190,872410,718653,571424,447781,592083,824483,583176,918127,925941,147648,552496,456405,382590,158348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]