SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354518 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354518 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523817,987481,840760,916039,862421,32945,293749,668044,119483,880030,548739,961658,31234,129035,1004783,932109,273209,566501,636477,476568,850834,415298,469120,839795,238862,892040,377272,872532,729034,731914,878080,158737,805689,788158,87653,893033,322818,776234,602193,981785,514780,57996,11938,797494,970487,47055,681387,239361,718026,516319,555337,286191,503796,124775,703563,804444,467718,162223,526888,527137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]