SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28571 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28571 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782462,499509,845902,101502,770990,967578,132383,575038,596320,150510,209509,358827,849937,273378,846570,729081,502800,81221,260932,389993,422974,335568,956341,468888,26863,277448,934788,371471,1038304,630629,580553,837584,729933,703390,999378,405103,683135,385985,451715,909432,717856,1012477,116830,151898,810167,203977,830469,709289,367131,565106,881205,918732,886254,288517,593192,890574,933457,43516,466244,972359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]