SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376187 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376187 [ RunTime:0.003691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871117,596565,70978,66932,850820,661326,912313,1038067,52771,817291,829801,273910,434383,26703,40383,378343,87004,225922,536740,939249,983058,356459,713133,343009,409462,377067,771414,287112,825129,147873,387873,287811,475320,107154,452570,589122,253700,263612,277533,933356,217900,41707,376972,887559,499313,911369,605416,503418,409810,609731,631992,1029718,218517,299665,914529,422517,735997,486687,84187,26001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005024s ]