SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498322 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498322 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281491,894164,229452,520709,942043,120109,926985,379679,729740,12360,918023,961290,668608,1016262,848303,883488,477973,974110,705272,263463,881655,220581,882134,905164,249212,401232,962380,30074,591459,626046,360789,400017,393578,728653,214960,316557,161954,101742,507887,451015,279920,648414,450466,987533,660837,460902,83134,468374,220527,737185,812977,925153,363128,267298,875609,228989,985898,708604,1042640,1018821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]