SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503187 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503187 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541267,215119,115329,47827,233668,135523,301531,696851,408018,162033,255714,404733,404948,963756,425951,723630,225328,260382,641347,355366,920399,817158,604069,161691,529287,498294,766468,402887,398681,893701,978816,421184,596766,159513,548902,1039033,798996,23559,694446,728419,49016,918758,57934,990210,1020635,896372,526149,855668,961628,41867,176534,381867,31974,747335,824287,561780,890448,401448,314616,28845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]