SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620526 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620526 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126380,309614,847528,152745,962736,167489,854038,235260,247259,581367,382850,1048051,918024,238275,895721,32514,380617,404901,462520,1042261,899156,861274,48019,530183,876101,543896,358432,877066,291172,143733,369827,60102,60083,413731,974637,176464,436047,887566,327292,11765,924525,710861,47014,351843,6880,158083,738118,759122,659040,995598,912090,326486,960240,748898,902197,961893,765680,838943,677413,948219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]