SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022550 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022550 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407190,466834,885887,158241,729471,499215,30145,163281,144953,593555,779389,61764,710405,186993,568560,642061,644558,527945,291624,379560,1032684,145795,1020901,568553,372645,302697,670526,655631,364030,198183,562290,18238,771517,247480,285388,214622,61606,139108,770175,479754,866339,507955,332175,953410,400477,911904,219281,887504,452163,879624,636191,688293,119654,529084,994011,91972,995241,342906,10566,57028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]