SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554010 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554010 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625460,919593,635640,496312,556514,209075,797437,905874,412032,605549,551316,679097,548392,30007,1028015,108705,188953,648137,319779,604742,548038,445750,507843,873720,455094,1026405,356883,6202,693384,875796,675168,400356,637710,701918,652963,966978,960785,138511,777047,131803,901161,774613,579219,689963,102369,1029205,432236,153079,751739,57483,403273,120762,828544,617120,375976,272906,841328,929277,20904,347830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]