SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331604 LIMIT 1 [ RunTime:0.001879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331604 [ RunTime:0.003749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267831,230143,876457,23465,283418,781204,652652,314382,67210,716480,912246,981559,917334,873365,438459,409786,482340,541490,1039236,975296,308897,335191,368650,834516,260680,37570,929024,393819,373834,26055,375394,608511,187025,362497,624314,111503,744524,468453,786152,362563,421062,828783,767283,622151,514534,814699,14180,233266,830899,345991,727959,821591,474571,788601,680135,723577,200479,526630,331483,647747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]