SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450751 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450751 [ RunTime:0.004398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300548,10512,659274,131093,454243,905905,940270,372882,776910,403490,166188,1033302,781015,74282,703455,362384,74962,223655,180929,290726,136988,767180,314320,591857,122919,495648,373644,370680,978918,1017694,704566,264401,283332,75351,633728,1017949,166630,355683,154683,438549,896207,1043881,727773,648359,696246,528400,881002,191694,133560,665567,500952,978933,1032097,680430,482648,922616,936686,820464,872176,721065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]