SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800212 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800212 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206653,404932,499120,280753,1012626,602445,740675,623342,377210,18690,898528,31821,550051,38644,890859,588722,5994,970499,351788,552891,748852,805992,511551,406296,299677,473559,164997,795092,500150,650223,172860,122411,612873,189845,659750,411353,574755,835100,953337,558994,800450,471344,804168,102911,718379,77047,567883,404082,512883,226509,716027,902271,810587,159738,603956,19197,557617,257688,994866,899386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]