SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501037 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501037 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317404,343251,794919,566028,60177,395675,994290,305898,892843,934772,230566,400272,922146,718153,727435,179267,388315,315638,184364,915493,316095,209035,122079,713873,161886,445840,189837,27180,196271,12411,826175,857495,878116,68391,361323,659466,133718,967590,345889,195238,678729,682583,836034,476241,19907,869604,560174,329413,20902,141549,154586,207768,478087,1023281,530285,221275,310436,992093,962549,819873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]