SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030004 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030004 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125171,957024,370444,668876,1002285,659249,799454,784780,725792,105930,949891,545712,677305,982307,929528,466080,896907,266374,653592,653783,433934,714448,183823,741292,971980,693547,704459,218704,1033557,1002785,217280,1037508,647064,660277,543744,634806,285644,911527,216035,1025620,403706,745011,492340,99407,370961,457005,665571,677328,513586,358823,255820,50539,349693,313466,518628,759859,356628,445608,402546,445863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]