SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004404 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004404 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748043,962396,887780,750678,147181,611344,1047433,991391,33337,493699,65771,896531,861112,57411,606894,51270,170050,899155,874276,937944,701320,577029,900164,126910,1023259,273723,657791,133314,745970,726290,861395,755317,706725,940780,800849,342138,959096,139758,159947,560859,872501,445696,860283,834626,452889,604374,394466,419169,168496,979334,546282,320450,452651,782033,18337,117804,693070,72300,530708,124596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]