SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560541 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560541 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833173,409397,1015866,594463,437566,1000639,490747,426120,2178,256123,987138,836095,153972,781449,468272,570740,524771,863213,623370,559870,787928,533213,116886,978707,796517,43344,349340,585229,310913,923551,531938,878169,881126,527466,119746,66482,27423,46790,193901,1040808,24814,107013,258160,612172,1000288,10107,183285,1044578,343766,28421,392275,406239,549662,749151,411339,1026312,261869,243561,103946,161555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]