SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520324 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520324 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123153,841543,431600,966721,418828,874133,1034400,260093,725657,985242,725857,180526,533376,551353,220577,662214,48348,992278,710038,343316,346192,639198,630098,729569,874730,336202,905195,873856,452193,889650,961612,427830,967100,132374,922272,778010,800174,201434,932397,939615,551735,698230,857879,622922,50536,205612,215678,561783,461239,128470,887995,151848,316865,275015,154943,973425,925314,665350,769674,626323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]