SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040555 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040555 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354485,100499,802187,910281,539551,944695,193151,40841,79076,269042,724810,923536,193036,369060,875781,23275,60143,591718,835490,24576,308121,512810,640681,899833,167482,104431,233025,74616,752111,587535,811682,866963,66189,401373,709330,997601,923750,205753,708064,12240,455210,35547,1025042,94348,754086,588407,622833,945826,40697,301903,611619,436709,124568,242673,407769,522123,521377,242176,563063,328716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]