SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512482 LIMIT 1 [ RunTime:0.001161s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512482 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674126,763765,87534,475899,513858,636612,1044528,731161,77178,718469,261996,31760,932274,920542,792414,847668,192037,591873,889539,109107,556056,774928,73357,2975,64267,127394,1044607,701153,33930,149604,865799,158862,16946,821550,950076,450949,830892,810555,99388,221524,91560,25584,877684,309222,736315,727103,948572,696670,100009,317898,491800,564395,821591,700416,355206,877756,448323,148806,672258,820481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004082s ]