SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511534 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511534 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982251,444389,991385,378911,697149,918788,376130,62426,788651,59937,749149,881387,840587,1042144,641078,383163,281824,540023,539327,153490,597679,988791,868790,136715,693912,405752,742072,175821,460424,258473,726929,294170,772059,312541,385864,755077,382935,432590,290391,990865,53471,655332,781163,990687,330726,474338,868434,725372,37761,175339,22609,938850,669427,205615,187675,59941,558724,951301,662006,487516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]