SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44651 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44651 [ RunTime:0.003575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833343,857909,430819,907438,173657,398025,811606,732292,876340,56898,66350,476619,217747,284694,1006056,417858,20379,670812,708236,273163,384209,266495,892151,391362,583181,522589,597669,714158,65992,69455,7623,289065,414704,925966,510132,556864,304705,402885,755131,834596,737874,734686,724131,804798,560713,876505,723094,212313,35704,960349,140570,226099,559952,157910,856746,341268,430579,693419,337967,178759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]