SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562676 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562676 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000825,378706,149581,1017259,886433,160894,808041,463835,973012,248987,253054,358036,683724,60633,946636,392720,12001,665436,189182,470611,408188,806504,39170,769978,402825,125239,379707,992872,555861,404470,576214,533990,699820,442210,1047212,294239,284617,173693,841167,1004860,654672,678043,489301,267294,41219,702691,180154,216077,896449,172224,698691,834213,995634,779777,486142,825422,1041428,593876,726641,311020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]