SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44574 LIMIT 1 [ RunTime:0.000762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44574 [ RunTime:0.005576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209275,1033251,406482,151086,240872,419295,327205,990773,751511,239153,975839,424624,356478,892358,169801,480050,997495,413061,167219,178235,46627,250503,703607,61809,81209,306182,634871,384678,865895,607339,710819,835860,342317,802239,158500,30524,125782,752580,963008,937699,148774,598631,294644,84245,126370,705275,778800,367044,590681,21504,841293,756388,126955,323150,771690,587733,797213,46384,419005,822362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]