SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80489 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80489 [ RunTime:0.005158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015392,680498,603042,945517,761813,3838,648010,918597,502888,124139,320161,264851,246989,36792,424900,421448,874699,612027,357884,687538,755997,305577,114891,233376,347565,220880,154874,907270,13917,668291,128514,842179,818778,748680,867999,563417,560713,1007320,1017411,112388,958226,136165,772789,1005329,782164,769450,914644,361225,357835,224297,866434,972564,882693,765360,284319,1046873,185957,812909,94884,612260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]