SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530571 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530571 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790218,847904,285882,348975,971025,47128,997179,545736,103666,244166,441652,975625,843244,367311,921943,796397,1037585,741171,516475,96627,224851,595790,751955,476241,352558,316989,972373,902167,831533,306121,95997,554702,976664,292262,384341,791898,569438,678132,628422,848009,661376,559094,543399,171766,858216,697261,624809,821293,798442,150130,672276,57727,1021770,495689,122123,533740,106291,434082,202234,1008989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]