SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562860 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562860 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103292,771618,38565,410197,356621,1000640,104711,133346,938326,806905,409312,707101,202437,740409,621603,89954,953325,677077,76203,206990,453684,136583,142683,379282,863152,622070,891636,163073,634900,806970,322602,965803,615183,39065,317355,278187,314858,75441,734015,565838,297076,312746,25229,615888,930173,552128,872515,735339,550242,1026471,712953,337319,616576,69109,397018,379325,446143,126204,295655,1045130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]