SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254517 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254517 [ RunTime:0.003735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509985,112751,555448,43003,245293,695366,735593,546534,618101,825908,764815,516180,732260,425398,143090,32232,550939,531104,349074,371405,877778,9169,853017,361327,794833,728721,602355,323170,885358,784318,288046,385688,357756,913292,186824,972677,50353,434819,52811,921773,391246,752013,1008318,42783,38492,995744,69201,764607,732409,254674,108830,544396,796042,237088,374110,1001082,294875,572490,371323,1004013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]