SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55006 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55006 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145009,790003,53794,900585,185761,581499,238472,791013,174794,499370,370582,977665,918360,965716,835031,144439,532065,745243,106788,425447,880601,139778,387412,909115,31568,527514,256967,136015,869551,826783,814470,695475,461280,350888,545572,596369,281226,284750,1022167,499171,758011,792555,587503,730015,866261,823108,684217,187659,976576,607560,372832,564675,828491,643602,582308,620536,775504,33214,226475,467708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]