SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101926 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101926 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298343,251494,1003002,952517,749593,300341,25350,761419,862857,309501,220930,832402,864573,68814,995609,586901,661053,205425,983181,154074,508100,850179,384203,460894,615517,845955,304662,28427,170047,64063,619745,334965,859200,920931,826055,721589,137389,70418,370539,651005,814925,662514,520740,561073,325770,177865,651646,343875,1021359,743133,728421,803703,770522,601144,461791,29676,578398,56852,859346,191293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]