SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011455 LIMIT 1 [ RunTime:0.001185s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011455 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5390,963160,680614,1012262,934437,469079,979525,610104,989548,986438,825155,290411,854312,599211,800693,86067,809379,254070,191433,688522,872698,67006,387231,221290,220723,727860,225548,321601,391680,852398,572567,604119,702801,974684,286320,186611,283305,539263,752007,259987,915784,804420,165001,118544,263666,713094,115428,609441,615337,973991,444242,266237,413737,484344,372719,1009962,258924,983773,975649,152153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]