SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550038 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550038 [ RunTime:0.003409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503635,956495,930437,342933,960782,459529,913968,285379,901676,342084,354317,100650,535248,989985,482207,466414,825203,165444,26406,522500,486273,928652,432457,456285,350372,482245,125148,712322,1018097,570363,762816,533237,479062,483111,646896,845439,946241,85135,740553,919095,42273,99177,1040648,276044,174628,942408,306286,871047,346659,686624,653084,609475,246160,759322,895548,421499,481706,1012509,946489,874901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002546s ]