SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450790 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450790 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533875,78946,920752,880854,763681,1014883,662785,605972,226695,697871,45080,1035190,755481,959726,3477,83632,690126,162601,189516,296075,184,142451,768711,876934,158621,205634,967560,571688,127363,856332,816597,253781,198764,696817,413668,105791,550520,63249,608407,612098,891627,176511,779887,988412,860683,545364,93446,741093,867388,960907,877020,347620,968096,1013674,561805,793226,246248,948543,837366,97856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]