SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490882 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490882 [ RunTime:0.003084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384883,422685,960800,689753,1027804,5856,828377,436397,407357,832387,645384,942839,392878,988301,659958,362910,476030,889348,341874,1046750,625561,233149,483026,378925,5782,373853,646304,1015985,1000354,405454,155824,435426,869042,178634,30546,737861,744372,17585,284015,879851,711116,577314,305037,991413,129428,546586,1028833,624116,336741,479155,846763,280919,719744,886863,269066,508555,797785,786247,284021,332804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]