SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347613 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347613 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140250,653169,147073,711139,835801,725078,262690,789748,995400,1011098,317987,985152,363029,322754,581468,241589,305869,103095,1008247,116402,1023049,91369,941805,271636,125212,217503,738222,605402,270609,450878,422507,25558,362416,805530,715479,178944,394424,700426,4558,817291,277323,131382,606467,723987,573188,393975,812282,215309,75408,509010,738443,775805,67391,179369,329843,392813,802839,733392,298841,740239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]