SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309187 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309187 [ RunTime:0.003612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122410,683441,400028,368769,108130,487267,927771,280455,447371,752410,303769,389136,547795,317619,826021,994492,856540,557793,36563,12157,79141,504270,744566,650366,542456,705665,820091,634680,902397,995515,247453,187871,586237,749727,818724,359910,272859,554800,275902,776089,304129,830215,497280,574036,440985,110357,553035,94516,933164,969951,670911,47419,463943,1045588,406020,98846,800684,263432,333465,1043091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]