SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531871 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531871 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486242,464591,924797,381323,685565,1001321,842961,143863,380004,215325,1000181,144950,814538,8012,17311,872649,919541,689947,846666,669985,634762,819302,34361,486105,596288,509078,55760,346068,330227,702880,1041891,538000,933976,703878,588805,699978,129660,778995,465601,371046,828901,789215,721522,678936,310496,216558,656038,498855,164280,496334,885960,561302,290179,557561,228248,331201,516260,349701,544322,102474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]