SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504598 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504598 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725774,254525,118250,178804,367206,777396,263516,646616,82894,791973,287346,196707,976808,1000177,313126,232764,435132,246743,916737,840277,220773,461369,903544,892421,862816,343068,685780,958932,839482,568393,378505,665586,758089,207396,94667,2948,686360,765264,429538,443151,1014919,223871,411605,757887,89971,584493,384948,83287,495084,66902,644060,859389,948081,857515,870117,826746,448504,640468,743635,151389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]