SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473819 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473819 [ RunTime:0.003210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424742,395349,815580,385718,115537,563182,971735,202370,14801,393628,374880,889836,1043480,516838,458093,5470,502246,301425,919315,457512,597388,972296,926281,1046706,95853,235290,433449,604068,786369,1010033,396625,254024,913014,117282,297610,825676,417043,401988,321926,179882,675154,862724,645295,290315,11594,372451,5538,11931,327825,35965,106739,802108,27404,300404,434547,95971,917781,556147,226175,1014245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]