SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003205 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003205 [ RunTime:0.002786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177515,795614,260065,886257,904968,315887,1008094,453495,405184,871637,783603,248166,510414,258074,116779,725704,803292,68039,82642,33635,532203,27223,957009,384470,678978,542612,56284,822497,43886,397618,198790,152709,808344,878681,771635,1040182,600446,302402,946025,683799,67601,235923,501718,1015566,489227,235230,983473,586754,461419,768588,671612,844382,629878,149981,681719,617400,706490,546070,192959,584862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]