SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 946180 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 946180 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871273,144102,165443,38737,1031358,1042586,788201,863871,109830,228257,515856,936956,688938,621256,1189,710658,859739,695778,763660,668360,95835,421670,258271,387162,644132,557611,1039278,195046,70311,677745,66925,147104,141349,972859,552738,182453,531005,18750,279548,682192,466464,293654,716847,289151,540576,790754,279500,776470,714933,386483,367361,333523,47438,476157,215705,218775,31179,797543,23947,638910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 946180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 946180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]