SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439404 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439404 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896056,721383,1004740,877970,908887,686637,261709,170405,534596,613548,890622,13348,162298,387617,825337,339007,523118,909071,705769,1047930,90962,635690,603764,398539,528299,9126,854939,166381,717239,322731,439608,609840,915840,206973,451144,301514,683075,375067,598156,495466,82425,117487,664763,203774,82292,871877,474195,946188,520620,851155,913908,442026,516624,81611,324270,744763,405866,594464,782486,102218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]