SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687413 LIMIT 1 [ RunTime:0.000613s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687413 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009469,745541,94991,335991,962313,793255,537779,437714,796998,285845,824677,960674,812718,739898,737015,609326,470353,974478,180964,73606,994134,523005,426640,427756,734627,782586,666598,675847,901186,1021642,787746,415085,370667,434055,780114,375507,673127,93427,228064,7517,794634,823397,591223,1019944,241370,929562,293797,890555,1017323,497560,233919,362736,838100,480609,683470,989007,449320,963705,142089,773645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]