SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540984 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540984 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390583,937586,463956,646756,213149,196847,618833,1012005,12155,431915,154347,682683,407129,632988,851893,824107,595213,414409,306547,172073,1032172,499400,672684,914078,67642,421802,1030313,264012,408943,165128,164364,919278,2810,945391,740814,648958,283164,26594,64606,813914,370471,690081,517181,1032377,987942,521122,995519,245639,383639,527428,317455,479367,327805,671483,959483,216674,219113,11484,615930,407788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]