SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121039 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121039 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560874,224418,303262,495610,984334,820124,423345,1037836,154146,747448,984942,708416,363333,755065,657724,357605,625234,639635,1007606,772816,134353,14881,825929,740217,646624,15072,175640,590960,1023652,680691,458532,1033372,177944,501923,490234,696239,364428,250987,589563,170411,709240,386541,408539,465953,547894,734,752062,249782,502958,74396,324800,859810,129249,572511,400918,159906,385807,593133,931124,266752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]