SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415004 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415004 [ RunTime:0.003914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428706,714128,239918,826688,404203,397295,166451,1015766,605914,574311,665414,962600,440626,533172,409755,1017235,846278,893010,210979,691795,765996,541625,198520,469661,323479,772994,935346,961536,604320,159200,11597,1034370,784238,567018,8410,861034,466277,163322,204920,410537,749734,380890,84654,234659,585929,1006527,993686,95774,281165,985583,557494,954847,788079,460741,460953,708115,436506,1038321,103287,788904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]