SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283012 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283012 [ RunTime:0.002189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752275,1017161,876635,839995,420015,388408,431123,432750,503618,430121,221382,867707,494748,235057,227106,97232,224301,102337,436459,890250,432977,900322,957258,816592,142063,253867,812104,593998,503471,592531,631404,606653,492950,103450,3812,701648,344873,606911,681928,992980,129839,245962,418321,315309,45126,789151,929324,216081,945748,520664,472311,944809,935598,45069,63431,62039,906533,784223,382265,362418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]