SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423307 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423307 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720564,78821,661925,621991,920757,749982,863094,53864,321151,651212,520269,813271,168329,1011986,880318,237765,370218,458120,214512,968423,396395,371663,282164,427249,358864,423816,398039,610871,663552,96191,193456,136114,636948,490740,914518,664258,490433,912764,145542,200946,401705,696634,655887,721903,1046729,44569,74676,174200,342177,497608,1009797,583579,189836,979452,643513,600807,770626,457110,634730,958794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]