SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037262 LIMIT 1 [ RunTime:0.001446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037262 [ RunTime:0.004022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515878,390274,129739,180241,59167,966950,359247,895579,774575,852370,619744,800393,953333,120743,168572,683054,351299,761833,85699,446662,357326,517545,588185,1010971,984925,280989,516069,734008,647163,362763,747967,473630,308144,579114,532994,660351,687357,701420,291774,653237,670315,27960,174812,492478,591979,39527,69641,74617,665808,870993,1020596,976535,993486,197035,202235,787259,765292,152734,1037266,581907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]