SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984119 LIMIT 1 [ RunTime:0.002774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984119 [ RunTime:0.005045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682383,680204,884226,515555,269270,1017456,128972,302366,828036,332715,704001,267321,378305,182189,187363,462084,995128,1034983,461696,386092,421992,757433,762649,244061,115418,774809,600238,308093,52276,1022618,564682,1013421,967716,988254,312936,256547,130513,270863,1003233,826484,360813,398440,667460,874141,214850,447313,961565,80040,909010,656768,355353,803359,88310,981598,574288,527425,889330,908407,323894,188139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]