SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104292 LIMIT 1 [ RunTime:0.001164s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104292 [ RunTime:0.002939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185916,923469,1005222,827312,408751,984379,316028,420065,327295,440660,1032455,609555,174855,704277,12308,106804,718306,395858,1025770,120842,723621,928628,377996,880852,75046,65662,911061,227336,172848,426935,698691,760192,577936,836637,883072,441288,951342,485048,879912,752867,1021275,502078,445721,493283,980321,496247,330755,916371,431081,228758,68459,906179,991804,426597,43973,211468,824104,979380,169217,700851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]