SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000041 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000041 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836462,335261,93252,285981,556878,214712,918058,824860,971283,488716,71980,314132,981328,754836,729298,763347,363152,903281,45446,913659,143058,640462,708942,649393,1047801,772550,463487,104531,56202,908737,949527,59736,867024,375489,800518,295605,687538,565063,764554,529627,476071,458857,798777,727169,957601,436808,124823,1020149,622294,260738,851765,872829,595900,408486,665757,362939,348873,496148,371452,161433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]