SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482711 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482711 [ RunTime:0.004677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486742,1024117,201674,359618,638601,781441,414699,897163,682716,254607,409039,970044,251232,767119,1047070,643814,58899,661521,726319,68304,981488,286997,751805,270019,260406,901219,780515,674176,831422,680547,272846,723665,122518,546975,161100,660565,71180,759054,952559,444771,801568,563614,815440,202124,821984,4247,561451,586177,992741,670540,748990,103845,227670,774940,86433,500615,984261,1044837,275800,721707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]