SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386421 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386421 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111860,501949,19078,425123,823833,363979,507627,12899,974811,1001310,724599,67509,704868,428044,296548,426981,667186,429637,603667,899376,417523,37862,523700,666320,201184,623515,20706,100039,995250,295942,694307,22579,507930,1044700,801125,728671,588182,422008,444507,653772,266329,803250,749200,889379,209582,198164,521529,13490,50546,954215,85920,108659,830839,306254,462181,775449,807574,608431,833784,668007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000794s ]