SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409512 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409512 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749184,878023,488465,556697,855975,421712,177895,158726,287743,796147,924604,444344,249786,927615,311057,538753,663078,997273,541336,492470,882614,886105,430712,510766,873665,798972,826453,323562,663113,668118,782816,1003332,679370,464173,368564,738616,642820,1036272,479207,449039,344742,809478,233871,86892,14845,559058,69334,1028460,724159,992747,198839,151693,786094,795910,124211,1012299,21824,928376,977374,315617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]