SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107409 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107409 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108706,934693,594328,1005836,673521,460917,542326,85678,257831,21277,926381,514522,965672,441780,848169,31301,749604,232002,81159,95099,425208,554103,549043,419200,739394,891535,730006,861113,489599,972741,705320,681212,872041,951786,624306,701564,811676,246548,235529,757820,190887,814062,871790,566780,694290,1042291,187690,879652,614303,216031,416853,971549,212849,68963,427697,336712,456138,601940,253180,805695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]