SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535809 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535809 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723327,1000652,689950,851172,132940,1005151,875784,332663,470987,18592,76938,721788,619269,853673,380550,721210,459879,284414,264298,448906,861352,505832,361778,155432,143355,48871,832211,851381,225272,401348,475847,503579,994977,927380,782975,691066,893819,11144,252526,27285,770199,662560,136445,453286,400332,949489,194093,286168,173076,973885,244668,932626,141128,724518,128771,665559,217763,686636,887563,914529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]