SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910571 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910571 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912642,990320,574390,514366,849572,895709,926538,246248,1157,437030,780206,184323,507258,226283,138100,691800,243202,147831,96597,581702,244657,923749,636642,884162,804613,973734,36435,755108,909295,81903,743396,647222,623605,466881,1048321,122392,868415,144476,965920,434961,788587,329445,613060,5427,270265,880075,488791,297310,312836,256477,388086,955655,59305,871634,523977,226068,347738,635794,290686,78986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]