SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004294 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004294 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014536,640221,759695,14127,160811,867562,460625,331441,1039204,719751,265530,796020,432995,250087,162658,916415,975872,136440,715095,882131,145383,209897,840292,517776,617085,583321,455715,754465,218854,847537,494753,436561,543003,273850,700468,572225,23481,229151,90197,69924,605160,370379,459152,152449,647781,696101,748750,403322,836047,1010752,788931,347283,778464,375367,705143,34133,56594,742757,533092,814974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]