SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405940 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405940 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658547,802046,1005050,149766,393930,467401,123435,656092,713897,378122,839263,627034,181517,318466,941301,415251,933774,874243,205727,851550,310810,359901,392791,533835,1039500,737118,269500,842688,665375,90158,34706,306130,780722,58408,656418,112031,126409,402790,250929,998961,867117,222960,483626,411578,103416,354772,759725,829808,82299,639892,699177,545877,348660,101801,1014427,964198,47945,363611,163347,91659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]