SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551928 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551928 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513717,334017,560289,533900,72312,913875,765614,736528,951615,381179,71009,66614,771507,391686,464007,919934,167974,355490,510098,886437,579462,139709,255151,376520,871786,537424,508517,690045,437606,344253,781290,232873,821127,474829,719149,380090,1038640,357319,722065,665487,161163,1019085,574170,222538,944540,788787,516508,308173,817890,233339,434338,555902,48734,529176,178066,875536,504720,165850,206142,99400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]