SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034912 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034912 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204527,189985,827251,240482,11230,871332,18401,226804,178565,767387,938454,637450,129178,51962,915532,1020938,110284,21644,479109,404580,696582,608762,34052,83972,751340,150975,80756,496357,999627,544112,75490,89395,987382,1024889,237473,879332,694828,655327,844308,778394,380759,760850,427907,570453,395943,289070,599494,991323,370938,147561,222508,329196,768060,350805,1013898,846327,35816,772734,462186,56490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]