SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803139 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803139 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290563,50667,620884,758654,713930,410280,642482,130030,918386,774649,214317,165125,419571,770681,647812,543608,182362,262397,946085,600065,555855,866807,669218,584737,839657,278525,992534,310355,861772,136638,98162,576868,762640,505683,578033,208055,270432,294558,668405,251591,1034391,956602,239880,623459,749673,469072,807710,298672,688117,474201,827818,1029300,7264,669815,844860,386126,477018,837957,254182,1014778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]