SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505022 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505022 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295352,596561,536864,155251,762352,689869,239226,805735,528401,220376,300292,282022,282185,98150,901960,161223,320369,127842,918444,601743,670069,231586,428867,460080,241051,490467,993591,19038,847169,200429,434090,40203,240273,703456,894152,973545,859595,407958,1032811,854189,963864,82180,819824,108946,349591,446436,937544,164339,506365,992833,749167,288675,827935,783982,518847,1027880,657234,517046,959204,991444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]