SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920168 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920168 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590071,419214,559739,429477,839267,555139,480547,1008216,668096,193979,324442,460344,446895,239663,153620,654581,779756,200985,701510,182151,664087,802164,580735,935762,228073,502341,261322,920182,512779,532692,209383,669136,9663,48151,104545,821870,424734,146367,817892,410184,199988,67404,165279,378139,781212,2229,1048256,577798,722967,331733,654967,855416,595075,268007,61149,973969,868691,96897,393667,870043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]