SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566860 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566860 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215099,745720,292881,136597,481430,835727,199397,524393,11755,88273,470745,379358,83528,732006,162399,769408,405649,901673,111532,603143,770288,919013,370352,494081,432289,61875,778931,199003,52114,39176,286926,831052,614818,157145,1038432,31748,503236,512153,1015459,888721,824248,647798,630313,516748,149765,417174,43464,910354,898548,568473,990436,175648,624315,754925,569012,600290,62519,400123,711628,456641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]