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` = 299581 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299581 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705037,488037,1017310,1006590,78418,720259,46116,601580,310530,988440,152562,166338,408012,397133,847910,943028,213579,166440,926852,795764,838275,196382,1013096,211518,164214,1032978,894390,165328,330036,780012,718605,689437,357280,186680,703856,255672,573786,846222,149875,129996,673399,203909,722339,645573,379331,648853,550332,374230,931447,35517,887378,208867,431326,520076,701465,982358,33804,220595,484047,428513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]