SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465654 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465654 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025091,681841,3477,337073,529979,185500,152832,991774,79353,838986,504599,260702,721915,761324,296620,710991,949666,971096,430627,998679,200214,1016195,673711,647155,42884,52716,167150,637118,130206,352499,566076,68392,512130,18302,461015,678185,582175,449304,865310,673944,830646,649426,578551,972254,1045369,27764,462242,743696,211479,1007149,604533,576367,358542,542085,670257,322862,206423,401402,715880,657589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]