SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 628852 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 628852 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563870,435216,1025131,320318,968112,413288,1028178,565949,142929,382860,154452,552988,177745,658861,933929,288721,694398,441848,437491,892368,472264,609349,641094,885013,930824,284559,218993,882438,16606,65708,916999,492889,615393,375220,374848,106374,1012447,858754,581786,197104,537655,350520,154482,262452,727830,28091,821395,842160,993192,582188,133990,846858,710376,722378,411551,880444,925121,358543,708777,364066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 628852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 628852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]