SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519809 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519809 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026392,222007,818219,291509,187639,634676,159303,949095,476736,829549,114181,464143,935803,218265,586423,550493,406975,174308,5915,827780,652857,39101,436329,241690,548092,561889,646185,63753,222441,230113,886801,583046,1037220,1017227,518479,141970,382793,677803,278536,875993,383588,988771,757634,353581,706766,342028,967320,389412,355578,346528,64390,61456,870664,726417,444459,1043216,596756,406681,769085,318449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001010s ]