SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29418 LIMIT 1 [ RunTime:0.000696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29418 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482623,798816,493249,767834,172838,548994,444271,1014075,521882,788330,992834,638197,484231,59668,1028963,235289,617137,116738,720881,525528,650005,319986,916252,182930,88193,693342,695944,696997,847048,957372,490382,334102,287758,286643,648968,588105,838043,790071,455219,143258,702085,740014,973570,47794,23394,779213,13357,59174,278083,111034,797654,203168,76596,1035499,65340,823332,169213,468719,573227,131681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]