SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520208 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520208 [ RunTime:0.002938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844423,646480,251999,662413,700180,589945,317773,428610,580338,17241,634429,558922,737873,631070,154382,386280,866918,745055,767430,234626,420315,399885,287936,81403,1026477,727704,640312,74022,417511,1042220,520552,815425,634748,169672,859602,1008343,581000,333909,1028760,270294,570204,55037,247583,770891,335797,271738,162987,245175,657690,894204,240329,331618,977811,822246,502792,650369,999738,970187,880098,962044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001122s ]