SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006738s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461883 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461883 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862851,785603,441427,921576,644148,446932,41942,500509,1039192,191985,915019,936234,894138,178997,773012,309217,24201,468181,970093,1017169,994615,367890,868434,925150,440576,561973,555623,284277,41139,35530,263245,1031081,266198,367186,843941,526814,593378,505590,579622,20536,861452,502939,954885,402819,589443,878383,234304,876439,264679,68198,517119,119307,90022,496722,468363,96410,335054,642291,345700,155086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001993s ]