SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433700 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433700 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351400,563074,832654,627803,772003,951849,349864,906615,910841,97224,118912,138864,973079,842705,130252,95445,307282,973191,362396,34277,1034150,774020,65066,175632,393380,423310,328731,763664,838615,672754,661120,964109,68216,931320,221316,735721,804780,633446,279649,62741,904070,79674,984069,20437,346991,96185,399298,578080,384700,759470,817922,690011,4015,277452,165494,750625,463335,37946,928896,663430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]