SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448813 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448813 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220653,754280,317540,974555,330772,812976,740304,298193,235703,986539,97882,990159,854857,225623,859520,976812,1039366,987795,987020,265527,216142,418399,1024041,533603,642495,677297,75370,793042,721615,113358,446899,988141,370393,441935,77933,653792,1028685,448677,858455,348966,223430,931378,895817,452131,918618,875347,131069,489506,518389,366851,918805,389244,686069,516181,371728,141808,794897,95688,30597,785280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]