SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72573 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72573 [ RunTime:0.003512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600681,342458,493642,816089,332177,388559,490684,271187,332362,923880,214568,25643,765806,733260,551021,519607,894951,868806,545029,187144,42484,785172,577660,523391,664864,219985,703164,280140,262793,969771,467086,1041375,76097,924269,650683,12078,192971,1022838,35786,242833,339293,735427,653711,369244,964585,69913,716703,232071,517130,829049,722441,899904,939187,861330,579511,872656,616579,831358,175669,292733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]