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` = 1017398 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017398 [ RunTime:0.002709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789434,7991,214212,492483,603348,751046,733418,715416,605711,238934,811119,572501,285126,263071,737497,581855,184267,387226,572822,966693,831079,795246,292577,1042392,4400,384863,187612,58093,839106,447144,1026904,686331,349619,776690,529631,290736,554962,803270,654567,304265,205309,553542,573958,693321,345323,356678,742026,325787,909455,780384,944171,76462,37905,958156,548376,23292,15849,405625,280639,533436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]